﻿if exists (select * from dbo.sysobjects where name = 'sp_tblOrderDetail_GetBy_imgid')
	drop procedure [dbo].[sp_tblOrderDetail_GetBy_imgid]
Go 
CREATE PROCEDURE dbo.sp_tblOrderDetail_GetBy_imgid
@_imgid int
AS
	SELECT * FROM tblOrderDetail
 WHERE _imgid = @_imgid 
Go 
if exists (select * from dbo.sysobjects where name = 'sp_tblOrderDetail_GetBy_oid')
	drop procedure [dbo].[sp_tblOrderDetail_GetBy_oid]
Go 
CREATE PROCEDURE dbo.sp_tblOrderDetail_GetBy_oid
@_oid int
AS
	SELECT * FROM tblOrderDetail
 WHERE _oid = @_oid 
Go